www.gusucode.com > VC++ 客户管理系统(SQL Serve)-源码程序 > VC++ 客户管理系统(SQL Serve)-源码程序/code/Program/qlxr.cpp

    // qlxr.cpp : implementation file
//

#include "stdafx.h"
#include "khmanager.h"
#include "qlxr.h"
#include "ado.h"
#include "xlxr.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// qlxr dialog


qlxr::qlxr(CWnd* pParent /*=NULL*/)
	: CDialog(qlxr::IDD, pParent)
{
	//{{AFX_DATA_INIT(qlxr)
	//}}AFX_DATA_INIT
}


void qlxr::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(qlxr)
	DDX_Control(pDX, IDC_EDIT1, m_edit);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(qlxr, CDialog)
	//{{AFX_MSG_MAP(qlxr)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchangeCombo1)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// qlxr message handlers

BOOL qlxr::OnInitDialog() 
{
	CDialog::OnInitDialog();
	this->m_com1.AddString("联系人编号");
	this->m_com1.AddString("企业名称");
	this->m_com1.AddString("联系人姓名");
	this->m_com1.AddString("联系人性别");
	this->m_com1.AddString("年龄");
	this->m_com1.AddString("职位");
	this->m_com1.AddString("办公电话");
	this->m_com1.AddString("电子邮件");
	this->m_com1.AddString("手机");
		this->m_com2.AddString("like");
	this->m_com2.AddString("=");
//	this->m_com2.AddString(">");
//	this->m_com2.AddString("<");
//	this->m_com2.AddString("<>");
//	this->m_com2.AddString(">=");
//	this->m_com2.AddString("<=");
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|
		LVS_EX_FULLROWSELECT|
		LVS_EX_HEADERDRAGDROP|
		LVS_EX_ONECLICKACTIVATE);
	m_list.InsertColumn(0,"联系人编号");
	m_list.InsertColumn(1,"企业名称");
	m_list.InsertColumn(2,"联系人姓名");
	m_list.InsertColumn(3,"联系人性别");
	m_list.InsertColumn(4,"年龄");
	m_list.InsertColumn(5,"职位");
	m_list.InsertColumn(6,"办公电话");
	m_list.InsertColumn(7,"电子邮件");
	m_list.InsertColumn(8,"手机");
	m_list.SetColumnWidth(0,100);
m_list.SetColumnWidth(1,100);
m_list.SetColumnWidth(2,100);
m_list.SetColumnWidth(3,100);
m_list.SetColumnWidth(4,100);
m_list.SetColumnWidth(5,100);
m_list.SetColumnWidth(6,100);
m_list.SetColumnWidth(7,100);
m_list.SetColumnWidth(8,100);
this->loadlist();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void qlxr::OnButton2() 
{
this->EndDialog(true);	
}

void qlxr::OnButton1() 
{
	m_list.DeleteAllItems();
		ado rst;
		CString sql,edit1,com1,com2;
		this->m_edit.GetWindowText(edit1);
		this->m_com2.GetWindowText(com2);
		this->m_com1.GetWindowText(com1);
		if(edit1.IsEmpty())
		{MessageBox("请输入","提示");
			return;
		}
		if(com1.IsEmpty())
		{MessageBox("请输入","提示");
			return;
		}
		if(com2.IsEmpty())
		{MessageBox("请输入","提示");
			return;
		}
		if(com2 == "=")
			sql.Format("select * from tb_Client_lxrxx where %s %s '%s'",ssel,com2,edit1);
		else
			sql.Format("select * from tb_Client_lxrxx where %s %s '%s%s%s'",ssel,com2,"%",edit1,"%");
rst.Open(sql,adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj"));
rst.Move(ii);
}
rst.close();
	
}
void qlxr::loadlist()
{
	ado rst;
rst.Open("select * from tb_Client_lxrxx",adCmdText);
int recordcount=rst.GetRecordCount();
int ii;
for(ii=1;ii<=recordcount;ii++)
{
m_list.InsertItem(ii-1,"");
m_list.SetItemText(ii-1,0,rst.GetFieldValue("lxrxx_id"));
m_list.SetItemText(ii-1,1,rst.GetFieldValue("lxrxx_qymc"));
m_list.SetItemText(ii-1,2,rst.GetFieldValue("lxrxx_xm"));
m_list.SetItemText(ii-1,3,rst.GetFieldValue("lxrxx_xb"));
m_list.SetItemText(ii-1,4,rst.GetFieldValue("lxrxx_nl"));
m_list.SetItemText(ii-1,5,rst.GetFieldValue("lxrxx_zw"));
m_list.SetItemText(ii-1,6,rst.GetFieldValue("lxrxx_bgdh"));
m_list.SetItemText(ii-1,7,rst.GetFieldValue("lxrxx_Email"));
m_list.SetItemText(ii-1,8,rst.GetFieldValue("lxrxx_sj"));
rst.Move(ii);
}
rst.close();
}

void qlxr::OnSelchangeCombo1() 
{
	switch(m_com1.GetCurSel())
	{
	case 0:
		ssel="lxrxx_id";
		break;
			case 1:
		ssel="lxrxx_qymc";
		break;
			case 2:
		ssel="lxrxx_xm";
		break;
			case 3:
		ssel="lxrxx_xb";
		break;
			case 4:
		ssel="lxrxx_nl";
		break;
			case 5:
		ssel="lxrxx_zw";
		break;
			case 6:
		ssel="lxrxx_bgdh";
		break;
			case 7:
		ssel="lxrxx_Email";
		break;
			case 8:
		ssel="lxrxx_sj";
		break;
	}
	
}

void qlxr::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int i=m_list.GetHotItem();
	if(i<0)
	{return;}
	xlxr l;
	ado rst;
	CString ss;
	ss.Format("select * from tb_Client_lxrxx where lxrxx_id='%s'",m_list.GetItemText(i,0));
rst.rstOpen(ss);

l.edit1=rst.GetFieldValue("lxrxx_id");
l.com1=rst.GetFieldValue("lxrxx_qymc");
l.edit2=rst.GetFieldValue("lxrxx_xm");
l.com2=rst.GetFieldValue("lxrxx_xb");
l.edit3=rst.GetFieldValue("lxrxx_nl");
l.com3=rst.GetFieldValue("lxrxx_zw");
l.edit4=rst.GetFieldValue("lxrxx_bgdh");
l.edit5=rst.GetFieldValue("lxrxx_Email");
l.edit6=rst.GetFieldValue("lxrxx_sj");
l.date1=rst.GetFieldValue("lxrxx_csny");

l.edit7=rst.GetFieldValue("lxrxx_grjj");
l.date2=rst.GetFieldValue("lxrxx_djrq");
l.edit8=rst.GetFieldValue("lxrxx_xxdjr");
l.edit9=rst.GetFieldValue("lxrxx_bz");
rst.close();
l.DoModal();
	*pResult = 0;
}